Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Adjust an ORACLE schema image to an OpenEdge database

The Adjust Schema utility allows you to migrate schema changes from an ORACLE database and compare it to the same schema in an OpenEdge database. If you make changes in both your OpenEdge database and the same changes in ORACLE using ORACLE tools, pull those changes into the schema holder. The Adjust Schema utility will compare the OpenEdge database to the schema image and update the Progress attributes necessary for your 4GL code to run against both data sources.

To run the Adjust Schema utility:

Connect to the source Progress database.
Connect to the Schema Image Schema Holder.
From the DataServer menu in either the Data Administration tool or the Character Data Dictionary, choose DataServers ORACLE Utilities Schema Migration Tools Adjust Schema. The following dialog box appears:



Interface element	Description
Original Progress DB	Enter the name of the source OpenEdge database.
Schema Image	Enter the ORACLE database logical name. The logical database name is the name of the schema image.
Files To Compare	Either leave the default **all** for all objects to be compared or enter the names of tables, sequences, or Progress Views to be compared. If listing individual objects, the list must be a comma-separated list within a group of objects and semicolons must separate the groups. The groups are table, sequence, and view, and must be listed in that order.

Provide the information as described in the following table: